<?php
/**
*
* @package phpBB3
* @version $Id$
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
*/

/**
* @ignore
*/
 
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include_once($phpbb_root_path . 'common.' . $phpEx);
include_once($phpbb_root_path . 'includes/functions_display.' . $phpEx);
include_once($phpbb_root_path . 'sv_common.' . $phpEx);
include_once($phpbb_root_path . 'ofc/php-ofc-library/open-flash-chart.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup('stockvirtual');

$money = $user->data['user_money'];
$user_id 	= $user->data['user_id'];

if ($user_id == ANONYMOUS)
{
	login_box();
}
if ($auth->acl_getf_global('m_') == false)
{
	// no enough priviledge, return.
	login_box();
}

// Basic parameter data
$mode		= request_var('mode', '');

if ($mode == 'query_corp')
{
	$query_corp_id	= request_var('corp_id', '');
	
	// list all holders of the corp. 
	$holder_list = false;

	$sql 	= 'SELECT * FROM sv_holding_stock WHERE corp_id=' . $query_corp_id ;
	$result = $db->sql_query($sql); 
	while ($row = $db->sql_fetchrow($result))
	{
		if (is_valid_corp_id($row['corp_id']) == false)
		{
			continue;
		}
	
		$holder_list = true;	
		
		// Send vars to template
		$template->assign_block_vars('holder_list', array(
			'USER_ID'						=> $row['user_id'],
			'USERNAME'						=> get_username($row['user_id']),
			'CORP_ID'						=> $row['corp_id'],
			'CORP_NAME'						=> get_corp_chinese_name($row['corp_id']),
			'NUMBER'						=> (int)$row['share']/1000,
			'NUMBER_TO_SELL'				=> (int)$row['share_to_sell']/1000,			
			'COST'							=> $row['cost'],
			)
		);
	}
	
	// list all transactions of the corp. 
	$transaction_list = false;

	$sql 	= 'SELECT * FROM sv_transaction WHERE corp_id=' . $query_corp_id . ' ORDER BY request_time DESC';
	$result = $db->sql_query($sql); 
	while ($row = $db->sql_fetchrow($result))
	{
		if (is_valid_corp_id($row['corp_id']) == false)
		{
			continue;
		}
	
		$transaction_list = true;
	
		$deal_time = 0;
		if ((int)$row['deal_time'] != 0)
		{
			$deal_time = date('Y/m/d H:i:s', (int)$row['deal_time']);
		}
		$check_time = 0;
		if ((int)$row['check_time'] != 0)
		{
			$check_time = date('Y/m/d H:i:s', (int)$row['check_time']);
		}
		
		// Send vars to template
		$template->assign_block_vars('transaction_list', array(
			'USER_ID'						=> $row['user_id'],
			'USERNAME'						=> get_username($row['user_id']),
			'CORP_ID'						=> $row['corp_id'],
			'CORP_NAME'						=> get_corp_chinese_name($row['corp_id']),
			'NUMBER'						=> (int)$row['share']/1000,
			'ACTION'						=> $row['action'],
			'REQUEST_TIME'					=> date('Y/m/d H:i:s', (int)$row['request_time']),
			'PRICE'							=> $row['price'],
			'DEAL_TIME'						=> $deal_time,
			'NOTE'							=> $row['note'],
			'CHECK_TIME'					=> $check_time,
			'CHECK_STATUS'					=> $row['check_status'],
			)
		);
	}
}

display_forums('', $config['load_moderators']);

// include nav links.
include_nav_links();

// Assign index specific vars
$template->assign_vars(array(

	'FORUM_IMG'				=> $user->img('forum_read', 'NO_NEW_POSTS'),
	'FORUM_NEW_IMG'			=> $user->img('forum_unread', 'NEW_POSTS'),
	'FORUM_LOCKED_IMG'		=> $user->img('forum_read_locked', 'NO_NEW_POSTS_LOCKED'),
	'FORUM_NEW_LOCKED_IMG'	=> $user->img('forum_unread_locked', 'NO_NEW_POSTS_LOCKED'),

	'S_LOGIN_ACTION'			=> append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login'),
	'S_ADM_QUERY_CORP_ACTION'	=> append_sid("{$phpbb_root_path}adm_query.$phpEx", 'mode=query_corp'),
	'S_DISPLAY_BIRTHDAY_LIST'	=> ($config['load_birthdays']) ? true : false,
	'U_MONEY'					=> number_format($money),
	'S_LIST'					=> $list,
	'JASON_STRING'				=> $jason_string,
	
	'S_HOLDER_LIST'				=> $holder_list,
	'S_TRANSACTION_LIST'		=> $transaction_list,
	'S_QUERY_USER'				=> append_sid("{$phpbb_root_path}query_user.$phpEx", 'mode=query_user'),
	'S_CORP_ID'					=> $query_corp_id,
	
	'U_MARK_FORUMS'		=> ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}index.$phpEx", 'hash=' . generate_link_hash('global') . '&amp;mark=forums') : '',
	'U_MCP'				=> ($auth->acl_get('m_') || $auth->acl_getf_global('m_')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=front', true, $user->session_id) : '')
);

// Output page
page_header($user->lang['SV_HISTORY']);

$template->set_filenames(array(
	'body' => 'adm_query.html')
);

page_footer();

?>